package com.shelpe.services.sinbad.model;

import java.util.ArrayList;
import java.util.Date;
import java.util.Iterator;
import java.util.List;

public class RptCreativeExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public RptCreativeExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        protected void addCriterionForJDBCDate(String condition, Date value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value.getTime()), property);
        }

        protected void addCriterionForJDBCDate(String condition, List<Date> values, String property) {
            if (values == null || values.size() == 0) {
                throw new RuntimeException("Value list for " + property + " cannot be null or empty");
            }
            List<java.sql.Date> dateList = new ArrayList<java.sql.Date>();
            Iterator<Date> iter = values.iterator();
            while (iter.hasNext()) {
                dateList.add(new java.sql.Date(iter.next().getTime()));
            }
            addCriterion(condition, dateList, property);
        }

        protected void addCriterionForJDBCDate(String condition, Date value1, Date value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value1.getTime()), new java.sql.Date(value2.getTime()), property);
        }

        public Criteria andTaobaoUserIdIsNull() {
            addCriterion("taobao_user_id is null");
            return (Criteria) this;
        }

        public Criteria andTaobaoUserIdIsNotNull() {
            addCriterion("taobao_user_id is not null");
            return (Criteria) this;
        }

        public Criteria andTaobaoUserIdEqualTo(Long value) {
            addCriterion("taobao_user_id =", value, "taobaoUserId");
            return (Criteria) this;
        }

        public Criteria andTaobaoUserIdNotEqualTo(Long value) {
            addCriterion("taobao_user_id <>", value, "taobaoUserId");
            return (Criteria) this;
        }

        public Criteria andTaobaoUserIdGreaterThan(Long value) {
            addCriterion("taobao_user_id >", value, "taobaoUserId");
            return (Criteria) this;
        }

        public Criteria andTaobaoUserIdGreaterThanOrEqualTo(Long value) {
            addCriterion("taobao_user_id >=", value, "taobaoUserId");
            return (Criteria) this;
        }

        public Criteria andTaobaoUserIdLessThan(Long value) {
            addCriterion("taobao_user_id <", value, "taobaoUserId");
            return (Criteria) this;
        }

        public Criteria andTaobaoUserIdLessThanOrEqualTo(Long value) {
            addCriterion("taobao_user_id <=", value, "taobaoUserId");
            return (Criteria) this;
        }

        public Criteria andTaobaoUserIdIn(List<Long> values) {
            addCriterion("taobao_user_id in", values, "taobaoUserId");
            return (Criteria) this;
        }

        public Criteria andTaobaoUserIdNotIn(List<Long> values) {
            addCriterion("taobao_user_id not in", values, "taobaoUserId");
            return (Criteria) this;
        }

        public Criteria andTaobaoUserIdBetween(Long value1, Long value2) {
            addCriterion("taobao_user_id between", value1, value2, "taobaoUserId");
            return (Criteria) this;
        }

        public Criteria andTaobaoUserIdNotBetween(Long value1, Long value2) {
            addCriterion("taobao_user_id not between", value1, value2, "taobaoUserId");
            return (Criteria) this;
        }

        public Criteria andCampaignIdIsNull() {
            addCriterion("campaign_id is null");
            return (Criteria) this;
        }

        public Criteria andCampaignIdIsNotNull() {
            addCriterion("campaign_id is not null");
            return (Criteria) this;
        }

        public Criteria andCampaignIdEqualTo(Long value) {
            addCriterion("campaign_id =", value, "campaignId");
            return (Criteria) this;
        }

        public Criteria andCampaignIdNotEqualTo(Long value) {
            addCriterion("campaign_id <>", value, "campaignId");
            return (Criteria) this;
        }

        public Criteria andCampaignIdGreaterThan(Long value) {
            addCriterion("campaign_id >", value, "campaignId");
            return (Criteria) this;
        }

        public Criteria andCampaignIdGreaterThanOrEqualTo(Long value) {
            addCriterion("campaign_id >=", value, "campaignId");
            return (Criteria) this;
        }

        public Criteria andCampaignIdLessThan(Long value) {
            addCriterion("campaign_id <", value, "campaignId");
            return (Criteria) this;
        }

        public Criteria andCampaignIdLessThanOrEqualTo(Long value) {
            addCriterion("campaign_id <=", value, "campaignId");
            return (Criteria) this;
        }

        public Criteria andCampaignIdIn(List<Long> values) {
            addCriterion("campaign_id in", values, "campaignId");
            return (Criteria) this;
        }

        public Criteria andCampaignIdNotIn(List<Long> values) {
            addCriterion("campaign_id not in", values, "campaignId");
            return (Criteria) this;
        }

        public Criteria andCampaignIdBetween(Long value1, Long value2) {
            addCriterion("campaign_id between", value1, value2, "campaignId");
            return (Criteria) this;
        }

        public Criteria andCampaignIdNotBetween(Long value1, Long value2) {
            addCriterion("campaign_id not between", value1, value2, "campaignId");
            return (Criteria) this;
        }

        public Criteria andAdgroupIdIsNull() {
            addCriterion("adgroup_id is null");
            return (Criteria) this;
        }

        public Criteria andAdgroupIdIsNotNull() {
            addCriterion("adgroup_id is not null");
            return (Criteria) this;
        }

        public Criteria andAdgroupIdEqualTo(Long value) {
            addCriterion("adgroup_id =", value, "adgroupId");
            return (Criteria) this;
        }

        public Criteria andAdgroupIdNotEqualTo(Long value) {
            addCriterion("adgroup_id <>", value, "adgroupId");
            return (Criteria) this;
        }

        public Criteria andAdgroupIdGreaterThan(Long value) {
            addCriterion("adgroup_id >", value, "adgroupId");
            return (Criteria) this;
        }

        public Criteria andAdgroupIdGreaterThanOrEqualTo(Long value) {
            addCriterion("adgroup_id >=", value, "adgroupId");
            return (Criteria) this;
        }

        public Criteria andAdgroupIdLessThan(Long value) {
            addCriterion("adgroup_id <", value, "adgroupId");
            return (Criteria) this;
        }

        public Criteria andAdgroupIdLessThanOrEqualTo(Long value) {
            addCriterion("adgroup_id <=", value, "adgroupId");
            return (Criteria) this;
        }

        public Criteria andAdgroupIdIn(List<Long> values) {
            addCriterion("adgroup_id in", values, "adgroupId");
            return (Criteria) this;
        }

        public Criteria andAdgroupIdNotIn(List<Long> values) {
            addCriterion("adgroup_id not in", values, "adgroupId");
            return (Criteria) this;
        }

        public Criteria andAdgroupIdBetween(Long value1, Long value2) {
            addCriterion("adgroup_id between", value1, value2, "adgroupId");
            return (Criteria) this;
        }

        public Criteria andAdgroupIdNotBetween(Long value1, Long value2) {
            addCriterion("adgroup_id not between", value1, value2, "adgroupId");
            return (Criteria) this;
        }

        public Criteria andCreativeIdIsNull() {
            addCriterion("creative_id is null");
            return (Criteria) this;
        }

        public Criteria andCreativeIdIsNotNull() {
            addCriterion("creative_id is not null");
            return (Criteria) this;
        }

        public Criteria andCreativeIdEqualTo(Long value) {
            addCriterion("creative_id =", value, "creativeId");
            return (Criteria) this;
        }

        public Criteria andCreativeIdNotEqualTo(Long value) {
            addCriterion("creative_id <>", value, "creativeId");
            return (Criteria) this;
        }

        public Criteria andCreativeIdGreaterThan(Long value) {
            addCriterion("creative_id >", value, "creativeId");
            return (Criteria) this;
        }

        public Criteria andCreativeIdGreaterThanOrEqualTo(Long value) {
            addCriterion("creative_id >=", value, "creativeId");
            return (Criteria) this;
        }

        public Criteria andCreativeIdLessThan(Long value) {
            addCriterion("creative_id <", value, "creativeId");
            return (Criteria) this;
        }

        public Criteria andCreativeIdLessThanOrEqualTo(Long value) {
            addCriterion("creative_id <=", value, "creativeId");
            return (Criteria) this;
        }

        public Criteria andCreativeIdIn(List<Long> values) {
            addCriterion("creative_id in", values, "creativeId");
            return (Criteria) this;
        }

        public Criteria andCreativeIdNotIn(List<Long> values) {
            addCriterion("creative_id not in", values, "creativeId");
            return (Criteria) this;
        }

        public Criteria andCreativeIdBetween(Long value1, Long value2) {
            addCriterion("creative_id between", value1, value2, "creativeId");
            return (Criteria) this;
        }

        public Criteria andCreativeIdNotBetween(Long value1, Long value2) {
            addCriterion("creative_id not between", value1, value2, "creativeId");
            return (Criteria) this;
        }

        public Criteria andDateIsNull() {
            addCriterion("date is null");
            return (Criteria) this;
        }

        public Criteria andDateIsNotNull() {
            addCriterion("date is not null");
            return (Criteria) this;
        }

        public Criteria andDateEqualTo(Date value) {
            addCriterionForJDBCDate("date =", value, "date");
            return (Criteria) this;
        }

        public Criteria andDateNotEqualTo(Date value) {
            addCriterionForJDBCDate("date <>", value, "date");
            return (Criteria) this;
        }

        public Criteria andDateGreaterThan(Date value) {
            addCriterionForJDBCDate("date >", value, "date");
            return (Criteria) this;
        }

        public Criteria andDateGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("date >=", value, "date");
            return (Criteria) this;
        }

        public Criteria andDateLessThan(Date value) {
            addCriterionForJDBCDate("date <", value, "date");
            return (Criteria) this;
        }

        public Criteria andDateLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("date <=", value, "date");
            return (Criteria) this;
        }

        public Criteria andDateIn(List<Date> values) {
            addCriterionForJDBCDate("date in", values, "date");
            return (Criteria) this;
        }

        public Criteria andDateNotIn(List<Date> values) {
            addCriterionForJDBCDate("date not in", values, "date");
            return (Criteria) this;
        }

        public Criteria andDateBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("date between", value1, value2, "date");
            return (Criteria) this;
        }

        public Criteria andDateNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("date not between", value1, value2, "date");
            return (Criteria) this;
        }

        public Criteria andSourceIsNull() {
            addCriterion("source is null");
            return (Criteria) this;
        }

        public Criteria andSourceIsNotNull() {
            addCriterion("source is not null");
            return (Criteria) this;
        }

        public Criteria andSourceEqualTo(Byte value) {
            addCriterion("source =", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceNotEqualTo(Byte value) {
            addCriterion("source <>", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceGreaterThan(Byte value) {
            addCriterion("source >", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceGreaterThanOrEqualTo(Byte value) {
            addCriterion("source >=", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceLessThan(Byte value) {
            addCriterion("source <", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceLessThanOrEqualTo(Byte value) {
            addCriterion("source <=", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceIn(List<Byte> values) {
            addCriterion("source in", values, "source");
            return (Criteria) this;
        }

        public Criteria andSourceNotIn(List<Byte> values) {
            addCriterion("source not in", values, "source");
            return (Criteria) this;
        }

        public Criteria andSourceBetween(Byte value1, Byte value2) {
            addCriterion("source between", value1, value2, "source");
            return (Criteria) this;
        }

        public Criteria andSourceNotBetween(Byte value1, Byte value2) {
            addCriterion("source not between", value1, value2, "source");
            return (Criteria) this;
        }

        public Criteria andSearchTypeIsNull() {
            addCriterion("search_type is null");
            return (Criteria) this;
        }

        public Criteria andSearchTypeIsNotNull() {
            addCriterion("search_type is not null");
            return (Criteria) this;
        }

        public Criteria andSearchTypeEqualTo(Byte value) {
            addCriterion("search_type =", value, "searchType");
            return (Criteria) this;
        }

        public Criteria andSearchTypeNotEqualTo(Byte value) {
            addCriterion("search_type <>", value, "searchType");
            return (Criteria) this;
        }

        public Criteria andSearchTypeGreaterThan(Byte value) {
            addCriterion("search_type >", value, "searchType");
            return (Criteria) this;
        }

        public Criteria andSearchTypeGreaterThanOrEqualTo(Byte value) {
            addCriterion("search_type >=", value, "searchType");
            return (Criteria) this;
        }

        public Criteria andSearchTypeLessThan(Byte value) {
            addCriterion("search_type <", value, "searchType");
            return (Criteria) this;
        }

        public Criteria andSearchTypeLessThanOrEqualTo(Byte value) {
            addCriterion("search_type <=", value, "searchType");
            return (Criteria) this;
        }

        public Criteria andSearchTypeIn(List<Byte> values) {
            addCriterion("search_type in", values, "searchType");
            return (Criteria) this;
        }

        public Criteria andSearchTypeNotIn(List<Byte> values) {
            addCriterion("search_type not in", values, "searchType");
            return (Criteria) this;
        }

        public Criteria andSearchTypeBetween(Byte value1, Byte value2) {
            addCriterion("search_type between", value1, value2, "searchType");
            return (Criteria) this;
        }

        public Criteria andSearchTypeNotBetween(Byte value1, Byte value2) {
            addCriterion("search_type not between", value1, value2, "searchType");
            return (Criteria) this;
        }

        public Criteria andCpcIsNull() {
            addCriterion("cpc is null");
            return (Criteria) this;
        }

        public Criteria andCpcIsNotNull() {
            addCriterion("cpc is not null");
            return (Criteria) this;
        }

        public Criteria andCpcEqualTo(Float value) {
            addCriterion("cpc =", value, "cpc");
            return (Criteria) this;
        }

        public Criteria andCpcNotEqualTo(Float value) {
            addCriterion("cpc <>", value, "cpc");
            return (Criteria) this;
        }

        public Criteria andCpcGreaterThan(Float value) {
            addCriterion("cpc >", value, "cpc");
            return (Criteria) this;
        }

        public Criteria andCpcGreaterThanOrEqualTo(Float value) {
            addCriterion("cpc >=", value, "cpc");
            return (Criteria) this;
        }

        public Criteria andCpcLessThan(Float value) {
            addCriterion("cpc <", value, "cpc");
            return (Criteria) this;
        }

        public Criteria andCpcLessThanOrEqualTo(Float value) {
            addCriterion("cpc <=", value, "cpc");
            return (Criteria) this;
        }

        public Criteria andCpcIn(List<Float> values) {
            addCriterion("cpc in", values, "cpc");
            return (Criteria) this;
        }

        public Criteria andCpcNotIn(List<Float> values) {
            addCriterion("cpc not in", values, "cpc");
            return (Criteria) this;
        }

        public Criteria andCpcBetween(Float value1, Float value2) {
            addCriterion("cpc between", value1, value2, "cpc");
            return (Criteria) this;
        }

        public Criteria andCpcNotBetween(Float value1, Float value2) {
            addCriterion("cpc not between", value1, value2, "cpc");
            return (Criteria) this;
        }

        public Criteria andCtrIsNull() {
            addCriterion("ctr is null");
            return (Criteria) this;
        }

        public Criteria andCtrIsNotNull() {
            addCriterion("ctr is not null");
            return (Criteria) this;
        }

        public Criteria andCtrEqualTo(Float value) {
            addCriterion("ctr =", value, "ctr");
            return (Criteria) this;
        }

        public Criteria andCtrNotEqualTo(Float value) {
            addCriterion("ctr <>", value, "ctr");
            return (Criteria) this;
        }

        public Criteria andCtrGreaterThan(Float value) {
            addCriterion("ctr >", value, "ctr");
            return (Criteria) this;
        }

        public Criteria andCtrGreaterThanOrEqualTo(Float value) {
            addCriterion("ctr >=", value, "ctr");
            return (Criteria) this;
        }

        public Criteria andCtrLessThan(Float value) {
            addCriterion("ctr <", value, "ctr");
            return (Criteria) this;
        }

        public Criteria andCtrLessThanOrEqualTo(Float value) {
            addCriterion("ctr <=", value, "ctr");
            return (Criteria) this;
        }

        public Criteria andCtrIn(List<Float> values) {
            addCriterion("ctr in", values, "ctr");
            return (Criteria) this;
        }

        public Criteria andCtrNotIn(List<Float> values) {
            addCriterion("ctr not in", values, "ctr");
            return (Criteria) this;
        }

        public Criteria andCtrBetween(Float value1, Float value2) {
            addCriterion("ctr between", value1, value2, "ctr");
            return (Criteria) this;
        }

        public Criteria andCtrNotBetween(Float value1, Float value2) {
            addCriterion("ctr not between", value1, value2, "ctr");
            return (Criteria) this;
        }

        public Criteria andImpressionsIsNull() {
            addCriterion("impressions is null");
            return (Criteria) this;
        }

        public Criteria andImpressionsIsNotNull() {
            addCriterion("impressions is not null");
            return (Criteria) this;
        }

        public Criteria andImpressionsEqualTo(Integer value) {
            addCriterion("impressions =", value, "impressions");
            return (Criteria) this;
        }

        public Criteria andImpressionsNotEqualTo(Integer value) {
            addCriterion("impressions <>", value, "impressions");
            return (Criteria) this;
        }

        public Criteria andImpressionsGreaterThan(Integer value) {
            addCriterion("impressions >", value, "impressions");
            return (Criteria) this;
        }

        public Criteria andImpressionsGreaterThanOrEqualTo(Integer value) {
            addCriterion("impressions >=", value, "impressions");
            return (Criteria) this;
        }

        public Criteria andImpressionsLessThan(Integer value) {
            addCriterion("impressions <", value, "impressions");
            return (Criteria) this;
        }

        public Criteria andImpressionsLessThanOrEqualTo(Integer value) {
            addCriterion("impressions <=", value, "impressions");
            return (Criteria) this;
        }

        public Criteria andImpressionsIn(List<Integer> values) {
            addCriterion("impressions in", values, "impressions");
            return (Criteria) this;
        }

        public Criteria andImpressionsNotIn(List<Integer> values) {
            addCriterion("impressions not in", values, "impressions");
            return (Criteria) this;
        }

        public Criteria andImpressionsBetween(Integer value1, Integer value2) {
            addCriterion("impressions between", value1, value2, "impressions");
            return (Criteria) this;
        }

        public Criteria andImpressionsNotBetween(Integer value1, Integer value2) {
            addCriterion("impressions not between", value1, value2, "impressions");
            return (Criteria) this;
        }

        public Criteria andCpmIsNull() {
            addCriterion("cpm is null");
            return (Criteria) this;
        }

        public Criteria andCpmIsNotNull() {
            addCriterion("cpm is not null");
            return (Criteria) this;
        }

        public Criteria andCpmEqualTo(Float value) {
            addCriterion("cpm =", value, "cpm");
            return (Criteria) this;
        }

        public Criteria andCpmNotEqualTo(Float value) {
            addCriterion("cpm <>", value, "cpm");
            return (Criteria) this;
        }

        public Criteria andCpmGreaterThan(Float value) {
            addCriterion("cpm >", value, "cpm");
            return (Criteria) this;
        }

        public Criteria andCpmGreaterThanOrEqualTo(Float value) {
            addCriterion("cpm >=", value, "cpm");
            return (Criteria) this;
        }

        public Criteria andCpmLessThan(Float value) {
            addCriterion("cpm <", value, "cpm");
            return (Criteria) this;
        }

        public Criteria andCpmLessThanOrEqualTo(Float value) {
            addCriterion("cpm <=", value, "cpm");
            return (Criteria) this;
        }

        public Criteria andCpmIn(List<Float> values) {
            addCriterion("cpm in", values, "cpm");
            return (Criteria) this;
        }

        public Criteria andCpmNotIn(List<Float> values) {
            addCriterion("cpm not in", values, "cpm");
            return (Criteria) this;
        }

        public Criteria andCpmBetween(Float value1, Float value2) {
            addCriterion("cpm between", value1, value2, "cpm");
            return (Criteria) this;
        }

        public Criteria andCpmNotBetween(Float value1, Float value2) {
            addCriterion("cpm not between", value1, value2, "cpm");
            return (Criteria) this;
        }

        public Criteria andClickIsNull() {
            addCriterion("click is null");
            return (Criteria) this;
        }

        public Criteria andClickIsNotNull() {
            addCriterion("click is not null");
            return (Criteria) this;
        }

        public Criteria andClickEqualTo(Integer value) {
            addCriterion("click =", value, "click");
            return (Criteria) this;
        }

        public Criteria andClickNotEqualTo(Integer value) {
            addCriterion("click <>", value, "click");
            return (Criteria) this;
        }

        public Criteria andClickGreaterThan(Integer value) {
            addCriterion("click >", value, "click");
            return (Criteria) this;
        }

        public Criteria andClickGreaterThanOrEqualTo(Integer value) {
            addCriterion("click >=", value, "click");
            return (Criteria) this;
        }

        public Criteria andClickLessThan(Integer value) {
            addCriterion("click <", value, "click");
            return (Criteria) this;
        }

        public Criteria andClickLessThanOrEqualTo(Integer value) {
            addCriterion("click <=", value, "click");
            return (Criteria) this;
        }

        public Criteria andClickIn(List<Integer> values) {
            addCriterion("click in", values, "click");
            return (Criteria) this;
        }

        public Criteria andClickNotIn(List<Integer> values) {
            addCriterion("click not in", values, "click");
            return (Criteria) this;
        }

        public Criteria andClickBetween(Integer value1, Integer value2) {
            addCriterion("click between", value1, value2, "click");
            return (Criteria) this;
        }

        public Criteria andClickNotBetween(Integer value1, Integer value2) {
            addCriterion("click not between", value1, value2, "click");
            return (Criteria) this;
        }

        public Criteria andCostIsNull() {
            addCriterion("cost is null");
            return (Criteria) this;
        }

        public Criteria andCostIsNotNull() {
            addCriterion("cost is not null");
            return (Criteria) this;
        }

        public Criteria andCostEqualTo(Integer value) {
            addCriterion("cost =", value, "cost");
            return (Criteria) this;
        }

        public Criteria andCostNotEqualTo(Integer value) {
            addCriterion("cost <>", value, "cost");
            return (Criteria) this;
        }

        public Criteria andCostGreaterThan(Integer value) {
            addCriterion("cost >", value, "cost");
            return (Criteria) this;
        }

        public Criteria andCostGreaterThanOrEqualTo(Integer value) {
            addCriterion("cost >=", value, "cost");
            return (Criteria) this;
        }

        public Criteria andCostLessThan(Integer value) {
            addCriterion("cost <", value, "cost");
            return (Criteria) this;
        }

        public Criteria andCostLessThanOrEqualTo(Integer value) {
            addCriterion("cost <=", value, "cost");
            return (Criteria) this;
        }

        public Criteria andCostIn(List<Integer> values) {
            addCriterion("cost in", values, "cost");
            return (Criteria) this;
        }

        public Criteria andCostNotIn(List<Integer> values) {
            addCriterion("cost not in", values, "cost");
            return (Criteria) this;
        }

        public Criteria andCostBetween(Integer value1, Integer value2) {
            addCriterion("cost between", value1, value2, "cost");
            return (Criteria) this;
        }

        public Criteria andCostNotBetween(Integer value1, Integer value2) {
            addCriterion("cost not between", value1, value2, "cost");
            return (Criteria) this;
        }

        public Criteria andDirectPayIsNull() {
            addCriterion("direct_pay is null");
            return (Criteria) this;
        }

        public Criteria andDirectPayIsNotNull() {
            addCriterion("direct_pay is not null");
            return (Criteria) this;
        }

        public Criteria andDirectPayEqualTo(Integer value) {
            addCriterion("direct_pay =", value, "directPay");
            return (Criteria) this;
        }

        public Criteria andDirectPayNotEqualTo(Integer value) {
            addCriterion("direct_pay <>", value, "directPay");
            return (Criteria) this;
        }

        public Criteria andDirectPayGreaterThan(Integer value) {
            addCriterion("direct_pay >", value, "directPay");
            return (Criteria) this;
        }

        public Criteria andDirectPayGreaterThanOrEqualTo(Integer value) {
            addCriterion("direct_pay >=", value, "directPay");
            return (Criteria) this;
        }

        public Criteria andDirectPayLessThan(Integer value) {
            addCriterion("direct_pay <", value, "directPay");
            return (Criteria) this;
        }

        public Criteria andDirectPayLessThanOrEqualTo(Integer value) {
            addCriterion("direct_pay <=", value, "directPay");
            return (Criteria) this;
        }

        public Criteria andDirectPayIn(List<Integer> values) {
            addCriterion("direct_pay in", values, "directPay");
            return (Criteria) this;
        }

        public Criteria andDirectPayNotIn(List<Integer> values) {
            addCriterion("direct_pay not in", values, "directPay");
            return (Criteria) this;
        }

        public Criteria andDirectPayBetween(Integer value1, Integer value2) {
            addCriterion("direct_pay between", value1, value2, "directPay");
            return (Criteria) this;
        }

        public Criteria andDirectPayNotBetween(Integer value1, Integer value2) {
            addCriterion("direct_pay not between", value1, value2, "directPay");
            return (Criteria) this;
        }

        public Criteria andIndirectPayIsNull() {
            addCriterion("indirect_pay is null");
            return (Criteria) this;
        }

        public Criteria andIndirectPayIsNotNull() {
            addCriterion("indirect_pay is not null");
            return (Criteria) this;
        }

        public Criteria andIndirectPayEqualTo(Integer value) {
            addCriterion("indirect_pay =", value, "indirectPay");
            return (Criteria) this;
        }

        public Criteria andIndirectPayNotEqualTo(Integer value) {
            addCriterion("indirect_pay <>", value, "indirectPay");
            return (Criteria) this;
        }

        public Criteria andIndirectPayGreaterThan(Integer value) {
            addCriterion("indirect_pay >", value, "indirectPay");
            return (Criteria) this;
        }

        public Criteria andIndirectPayGreaterThanOrEqualTo(Integer value) {
            addCriterion("indirect_pay >=", value, "indirectPay");
            return (Criteria) this;
        }

        public Criteria andIndirectPayLessThan(Integer value) {
            addCriterion("indirect_pay <", value, "indirectPay");
            return (Criteria) this;
        }

        public Criteria andIndirectPayLessThanOrEqualTo(Integer value) {
            addCriterion("indirect_pay <=", value, "indirectPay");
            return (Criteria) this;
        }

        public Criteria andIndirectPayIn(List<Integer> values) {
            addCriterion("indirect_pay in", values, "indirectPay");
            return (Criteria) this;
        }

        public Criteria andIndirectPayNotIn(List<Integer> values) {
            addCriterion("indirect_pay not in", values, "indirectPay");
            return (Criteria) this;
        }

        public Criteria andIndirectPayBetween(Integer value1, Integer value2) {
            addCriterion("indirect_pay between", value1, value2, "indirectPay");
            return (Criteria) this;
        }

        public Criteria andIndirectPayNotBetween(Integer value1, Integer value2) {
            addCriterion("indirect_pay not between", value1, value2, "indirectPay");
            return (Criteria) this;
        }

        public Criteria andDirectPayCountIsNull() {
            addCriterion("direct_pay_count is null");
            return (Criteria) this;
        }

        public Criteria andDirectPayCountIsNotNull() {
            addCriterion("direct_pay_count is not null");
            return (Criteria) this;
        }

        public Criteria andDirectPayCountEqualTo(Integer value) {
            addCriterion("direct_pay_count =", value, "directPayCount");
            return (Criteria) this;
        }

        public Criteria andDirectPayCountNotEqualTo(Integer value) {
            addCriterion("direct_pay_count <>", value, "directPayCount");
            return (Criteria) this;
        }

        public Criteria andDirectPayCountGreaterThan(Integer value) {
            addCriterion("direct_pay_count >", value, "directPayCount");
            return (Criteria) this;
        }

        public Criteria andDirectPayCountGreaterThanOrEqualTo(Integer value) {
            addCriterion("direct_pay_count >=", value, "directPayCount");
            return (Criteria) this;
        }

        public Criteria andDirectPayCountLessThan(Integer value) {
            addCriterion("direct_pay_count <", value, "directPayCount");
            return (Criteria) this;
        }

        public Criteria andDirectPayCountLessThanOrEqualTo(Integer value) {
            addCriterion("direct_pay_count <=", value, "directPayCount");
            return (Criteria) this;
        }

        public Criteria andDirectPayCountIn(List<Integer> values) {
            addCriterion("direct_pay_count in", values, "directPayCount");
            return (Criteria) this;
        }

        public Criteria andDirectPayCountNotIn(List<Integer> values) {
            addCriterion("direct_pay_count not in", values, "directPayCount");
            return (Criteria) this;
        }

        public Criteria andDirectPayCountBetween(Integer value1, Integer value2) {
            addCriterion("direct_pay_count between", value1, value2, "directPayCount");
            return (Criteria) this;
        }

        public Criteria andDirectPayCountNotBetween(Integer value1, Integer value2) {
            addCriterion("direct_pay_count not between", value1, value2, "directPayCount");
            return (Criteria) this;
        }

        public Criteria andIndirectPayCountIsNull() {
            addCriterion("indirect_pay_count is null");
            return (Criteria) this;
        }

        public Criteria andIndirectPayCountIsNotNull() {
            addCriterion("indirect_pay_count is not null");
            return (Criteria) this;
        }

        public Criteria andIndirectPayCountEqualTo(Integer value) {
            addCriterion("indirect_pay_count =", value, "indirectPayCount");
            return (Criteria) this;
        }

        public Criteria andIndirectPayCountNotEqualTo(Integer value) {
            addCriterion("indirect_pay_count <>", value, "indirectPayCount");
            return (Criteria) this;
        }

        public Criteria andIndirectPayCountGreaterThan(Integer value) {
            addCriterion("indirect_pay_count >", value, "indirectPayCount");
            return (Criteria) this;
        }

        public Criteria andIndirectPayCountGreaterThanOrEqualTo(Integer value) {
            addCriterion("indirect_pay_count >=", value, "indirectPayCount");
            return (Criteria) this;
        }

        public Criteria andIndirectPayCountLessThan(Integer value) {
            addCriterion("indirect_pay_count <", value, "indirectPayCount");
            return (Criteria) this;
        }

        public Criteria andIndirectPayCountLessThanOrEqualTo(Integer value) {
            addCriterion("indirect_pay_count <=", value, "indirectPayCount");
            return (Criteria) this;
        }

        public Criteria andIndirectPayCountIn(List<Integer> values) {
            addCriterion("indirect_pay_count in", values, "indirectPayCount");
            return (Criteria) this;
        }

        public Criteria andIndirectPayCountNotIn(List<Integer> values) {
            addCriterion("indirect_pay_count not in", values, "indirectPayCount");
            return (Criteria) this;
        }

        public Criteria andIndirectPayCountBetween(Integer value1, Integer value2) {
            addCriterion("indirect_pay_count between", value1, value2, "indirectPayCount");
            return (Criteria) this;
        }

        public Criteria andIndirectPayCountNotBetween(Integer value1, Integer value2) {
            addCriterion("indirect_pay_count not between", value1, value2, "indirectPayCount");
            return (Criteria) this;
        }

        public Criteria andFavShopCountIsNull() {
            addCriterion("fav_shop_count is null");
            return (Criteria) this;
        }

        public Criteria andFavShopCountIsNotNull() {
            addCriterion("fav_shop_count is not null");
            return (Criteria) this;
        }

        public Criteria andFavShopCountEqualTo(Integer value) {
            addCriterion("fav_shop_count =", value, "favShopCount");
            return (Criteria) this;
        }

        public Criteria andFavShopCountNotEqualTo(Integer value) {
            addCriterion("fav_shop_count <>", value, "favShopCount");
            return (Criteria) this;
        }

        public Criteria andFavShopCountGreaterThan(Integer value) {
            addCriterion("fav_shop_count >", value, "favShopCount");
            return (Criteria) this;
        }

        public Criteria andFavShopCountGreaterThanOrEqualTo(Integer value) {
            addCriterion("fav_shop_count >=", value, "favShopCount");
            return (Criteria) this;
        }

        public Criteria andFavShopCountLessThan(Integer value) {
            addCriterion("fav_shop_count <", value, "favShopCount");
            return (Criteria) this;
        }

        public Criteria andFavShopCountLessThanOrEqualTo(Integer value) {
            addCriterion("fav_shop_count <=", value, "favShopCount");
            return (Criteria) this;
        }

        public Criteria andFavShopCountIn(List<Integer> values) {
            addCriterion("fav_shop_count in", values, "favShopCount");
            return (Criteria) this;
        }

        public Criteria andFavShopCountNotIn(List<Integer> values) {
            addCriterion("fav_shop_count not in", values, "favShopCount");
            return (Criteria) this;
        }

        public Criteria andFavShopCountBetween(Integer value1, Integer value2) {
            addCriterion("fav_shop_count between", value1, value2, "favShopCount");
            return (Criteria) this;
        }

        public Criteria andFavShopCountNotBetween(Integer value1, Integer value2) {
            addCriterion("fav_shop_count not between", value1, value2, "favShopCount");
            return (Criteria) this;
        }

        public Criteria andFavItemCountIsNull() {
            addCriterion("fav_item_count is null");
            return (Criteria) this;
        }

        public Criteria andFavItemCountIsNotNull() {
            addCriterion("fav_item_count is not null");
            return (Criteria) this;
        }

        public Criteria andFavItemCountEqualTo(Integer value) {
            addCriterion("fav_item_count =", value, "favItemCount");
            return (Criteria) this;
        }

        public Criteria andFavItemCountNotEqualTo(Integer value) {
            addCriterion("fav_item_count <>", value, "favItemCount");
            return (Criteria) this;
        }

        public Criteria andFavItemCountGreaterThan(Integer value) {
            addCriterion("fav_item_count >", value, "favItemCount");
            return (Criteria) this;
        }

        public Criteria andFavItemCountGreaterThanOrEqualTo(Integer value) {
            addCriterion("fav_item_count >=", value, "favItemCount");
            return (Criteria) this;
        }

        public Criteria andFavItemCountLessThan(Integer value) {
            addCriterion("fav_item_count <", value, "favItemCount");
            return (Criteria) this;
        }

        public Criteria andFavItemCountLessThanOrEqualTo(Integer value) {
            addCriterion("fav_item_count <=", value, "favItemCount");
            return (Criteria) this;
        }

        public Criteria andFavItemCountIn(List<Integer> values) {
            addCriterion("fav_item_count in", values, "favItemCount");
            return (Criteria) this;
        }

        public Criteria andFavItemCountNotIn(List<Integer> values) {
            addCriterion("fav_item_count not in", values, "favItemCount");
            return (Criteria) this;
        }

        public Criteria andFavItemCountBetween(Integer value1, Integer value2) {
            addCriterion("fav_item_count between", value1, value2, "favItemCount");
            return (Criteria) this;
        }

        public Criteria andFavItemCountNotBetween(Integer value1, Integer value2) {
            addCriterion("fav_item_count not between", value1, value2, "favItemCount");
            return (Criteria) this;
        }

        public Criteria andAvgposIsNull() {
            addCriterion("avgpos is null");
            return (Criteria) this;
        }

        public Criteria andAvgposIsNotNull() {
            addCriterion("avgpos is not null");
            return (Criteria) this;
        }

        public Criteria andAvgposEqualTo(Float value) {
            addCriterion("avgpos =", value, "avgpos");
            return (Criteria) this;
        }

        public Criteria andAvgposNotEqualTo(Float value) {
            addCriterion("avgpos <>", value, "avgpos");
            return (Criteria) this;
        }

        public Criteria andAvgposGreaterThan(Float value) {
            addCriterion("avgpos >", value, "avgpos");
            return (Criteria) this;
        }

        public Criteria andAvgposGreaterThanOrEqualTo(Float value) {
            addCriterion("avgpos >=", value, "avgpos");
            return (Criteria) this;
        }

        public Criteria andAvgposLessThan(Float value) {
            addCriterion("avgpos <", value, "avgpos");
            return (Criteria) this;
        }

        public Criteria andAvgposLessThanOrEqualTo(Float value) {
            addCriterion("avgpos <=", value, "avgpos");
            return (Criteria) this;
        }

        public Criteria andAvgposIn(List<Float> values) {
            addCriterion("avgpos in", values, "avgpos");
            return (Criteria) this;
        }

        public Criteria andAvgposNotIn(List<Float> values) {
            addCriterion("avgpos not in", values, "avgpos");
            return (Criteria) this;
        }

        public Criteria andAvgposBetween(Float value1, Float value2) {
            addCriterion("avgpos between", value1, value2, "avgpos");
            return (Criteria) this;
        }

        public Criteria andAvgposNotBetween(Float value1, Float value2) {
            addCriterion("avgpos not between", value1, value2, "avgpos");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}